package com.ict.txmsv2.mapper;

import com.ict.txmsv2.dto.StudentInfoQueryDto;
import com.ict.txmsv2.model.StudentInfo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author lht
 * @date 2021/4/21 - 21:33
 * @description: 工作室学生业绩信息dao
 */
public interface StudentInfoMapper {

    /**
     * 上传文件
     *
     * @param info
     * @return
     */
    int uploadFile(@Param("info") StudentInfo info);

    /**
     * 通过id删除文件
     *
     * @param id
     * @return
     */
    @Delete("delete * from student_info where id = #{id}")
    int deleteFileById(@Param("id") Integer id);

    /**
     * 模糊查询学生业绩信息
     * @param queryDto
     * @return
     */
    List<StudentInfo> fuzzyGetStudentInfoList(@Param("queryDto") StudentInfoQueryDto queryDto);
}
